=> '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Emailed' => array ( 'field_data' => array ( 'field' => 'Emailed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Data' => array ( 'field_data' => array ( 'field' => 'Data', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'ActivityID', ), 'GDN_ActivityComment' => array ( 'fields' => array ( 'ActivityCommentID' => array ( 'field_data' => array ( 'field' => 'ActivityCommentID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'ActivityID' => array ( 'field_data' => array ( 'field' => 'ActivityID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Body' => array ( 'field_data' => array ( 'field' => 'Body', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Format' => array ( 'field_data' => array ( 'field' => 'Format', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'ActivityCommentID', ), 'GDN_ActivityType' => array ( 'fields' => array ( 'ActivityTypeID' => array ( 'field_data' => array ( 'field' => 'ActivityTypeID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AllowComments' => array ( 'field_data' => array ( 'field' => 'AllowComments', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'ShowIcon' => array ( 'field_data' => array ( 'field' => 'ShowIcon', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'ProfileHeadline' => array ( 'field_data' => array ( 'field' => 'ProfileHeadline', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'FullHeadline' => array ( 'field_data' => array ( 'field' => 'FullHeadline', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RouteCode' => array ( 'field_data' => array ( 'field' => 'RouteCode', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Notify' => array ( 'field_data' => array ( 'field' => 'Notify', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Public' => array ( 'field_data' => array ( 'field' => 'Public', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'ActivityTypeID', ), 'GDN_AnalyticsLocal' => array ( 'fields' => array ( 'TimeSlot' => array ( 'field_data' => array ( 'field' => 'TimeSlot', 'type' => 'varchar(8)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Views' => array ( 'field_data' => array ( 'field' => 'Views', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'EmbedViews' => array ( 'field_data' => array ( 'field' => 'EmbedViews', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'TimeSlot', ), 'GDN_Attachment' => array ( 'fields' => array ( 'AttachmentID' => array ( 'field_data' => array ( 'field' => 'AttachmentID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignID' => array ( 'field_data' => array ( 'field' => 'ForeignID', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignUserID' => array ( 'field_data' => array ( 'field' => 'ForeignUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Source' => array ( 'field_data' => array ( 'field' => 'Source', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'SourceID' => array ( 'field_data' => array ( 'field' => 'SourceID', 'type' => 'varchar(32)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'SourceURL' => array ( 'field_data' => array ( 'field' => 'SourceURL', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'UpdateIPAddress' => array ( 'field_data' => array ( 'field' => 'UpdateIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'AttachmentID', ), 'GDN_Ban' => array ( 'fields' => array ( 'BanID' => array ( 'field_data' => array ( 'field' => 'BanID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'BanType' => array ( 'field_data' => array ( 'field' => 'BanType', 'type' => 'enum(\'IPAddress\',\'Name\',\'Email\')', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'BanValue' => array ( 'field_data' => array ( 'field' => 'BanValue', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Notes' => array ( 'field_data' => array ( 'field' => 'Notes', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CountUsers' => array ( 'field_data' => array ( 'field' => 'CountUsers', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountBlockedRegistrations' => array ( 'field_data' => array ( 'field' => 'CountBlockedRegistrations', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateIPAddress' => array ( 'field_data' => array ( 'field' => 'UpdateIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'BanID', ), 'GDN_Category' => array ( 'fields' => array ( 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'ParentCategoryID' => array ( 'field_data' => array ( 'field' => 'ParentCategoryID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'TreeLeft' => array ( 'field_data' => array ( 'field' => 'TreeLeft', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'TreeRight' => array ( 'field_data' => array ( 'field' => 'TreeRight', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Depth' => array ( 'field_data' => array ( 'field' => 'Depth', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountCategories' => array ( 'field_data' => array ( 'field' => 'CountCategories', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountDiscussions' => array ( 'field_data' => array ( 'field' => 'CountDiscussions', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountAllDiscussions' => array ( 'field_data' => array ( 'field' => 'CountAllDiscussions', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountComments' => array ( 'field_data' => array ( 'field' => 'CountComments', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountAllComments' => array ( 'field_data' => array ( 'field' => 'CountAllComments', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'LastCategoryID' => array ( 'field_data' => array ( 'field' => 'LastCategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateMarkedRead' => array ( 'field_data' => array ( 'field' => 'DateMarkedRead', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AllowDiscussions' => array ( 'field_data' => array ( 'field' => 'AllowDiscussions', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Archived' => array ( 'field_data' => array ( 'field' => 'Archived', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CanDelete' => array ( 'field_data' => array ( 'field' => 'CanDelete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UrlCode' => array ( 'field_data' => array ( 'field' => 'UrlCode', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Description' => array ( 'field_data' => array ( 'field' => 'Description', 'type' => 'varchar(500)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Sort' => array ( 'field_data' => array ( 'field' => 'Sort', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CssClass' => array ( 'field_data' => array ( 'field' => 'CssClass', 'type' => 'varchar(50)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Photo' => array ( 'field_data' => array ( 'field' => 'Photo', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'PermissionCategoryID' => array ( 'field_data' => array ( 'field' => 'PermissionCategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '-1', 'extra' => '', ), 'escape_type' => 1, ), 'PointsCategoryID' => array ( 'field_data' => array ( 'field' => 'PointsCategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'HideAllDiscussions' => array ( 'field_data' => array ( 'field' => 'HideAllDiscussions', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DisplayAs' => array ( 'field_data' => array ( 'field' => 'DisplayAs', 'type' => 'enum(\'Categories\',\'Discussions\',\'Flat\',\'Heading\',\'Default\')', 'null' => 'NO', 'key' => '', 'default' => 'Discussions', 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'LastCommentID' => array ( 'field_data' => array ( 'field' => 'LastCommentID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'LastDiscussionID' => array ( 'field_data' => array ( 'field' => 'LastDiscussionID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'LastDateInserted' => array ( 'field_data' => array ( 'field' => 'LastDateInserted', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AllowedDiscussionTypes' => array ( 'field_data' => array ( 'field' => 'AllowedDiscussionTypes', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DefaultDiscussionType' => array ( 'field_data' => array ( 'field' => 'DefaultDiscussionType', 'type' => 'varchar(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'CategoryID', ), 'GDN_Comment' => array ( 'fields' => array ( 'CommentID' => array ( 'field_data' => array ( 'field' => 'CommentID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'DiscussionID' => array ( 'field_data' => array ( 'field' => 'DiscussionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DeleteUserID' => array ( 'field_data' => array ( 'field' => 'DeleteUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Body' => array ( 'field_data' => array ( 'field' => 'Body', 'type' => 'text', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Format' => array ( 'field_data' => array ( 'field' => 'Format', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateDeleted' => array ( 'field_data' => array ( 'field' => 'DateDeleted', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateIPAddress' => array ( 'field_data' => array ( 'field' => 'UpdateIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Flag' => array ( 'field_data' => array ( 'field' => 'Flag', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'CommentID', ), 'GDN_Conversation' => array ( 'fields' => array ( 'ConversationID' => array ( 'field_data' => array ( 'field' => 'ConversationID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(10)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignID' => array ( 'field_data' => array ( 'field' => 'ForeignID', 'type' => 'varchar(40)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Subject' => array ( 'field_data' => array ( 'field' => 'Subject', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Contributors' => array ( 'field_data' => array ( 'field' => 'Contributors', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'FirstMessageID' => array ( 'field_data' => array ( 'field' => 'FirstMessageID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateIPAddress' => array ( 'field_data' => array ( 'field' => 'UpdateIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CountMessages' => array ( 'field_data' => array ( 'field' => 'CountMessages', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountParticipants' => array ( 'field_data' => array ( 'field' => 'CountParticipants', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'LastMessageID' => array ( 'field_data' => array ( 'field' => 'LastMessageID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RegardingID' => array ( 'field_data' => array ( 'field' => 'RegardingID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'ConversationID', ), 'GDN_ConversationMessage' => array ( 'fields' => array ( 'MessageID' => array ( 'field_data' => array ( 'field' => 'MessageID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'ConversationID' => array ( 'field_data' => array ( 'field' => 'ConversationID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Body' => array ( 'field_data' => array ( 'field' => 'Body', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Format' => array ( 'field_data' => array ( 'field' => 'Format', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'MessageID', ), 'GDN_Discussion' => array ( 'fields' => array ( 'DiscussionID' => array ( 'field_data' => array ( 'field' => 'DiscussionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(10)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignID' => array ( 'field_data' => array ( 'field' => 'ForeignID', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'FirstCommentID' => array ( 'field_data' => array ( 'field' => 'FirstCommentID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'LastCommentID' => array ( 'field_data' => array ( 'field' => 'LastCommentID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Body' => array ( 'field_data' => array ( 'field' => 'Body', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Format' => array ( 'field_data' => array ( 'field' => 'Format', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Tags' => array ( 'field_data' => array ( 'field' => 'Tags', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CountComments' => array ( 'field_data' => array ( 'field' => 'CountComments', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountBookmarks' => array ( 'field_data' => array ( 'field' => 'CountBookmarks', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountViews' => array ( 'field_data' => array ( 'field' => 'CountViews', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Closed' => array ( 'field_data' => array ( 'field' => 'Closed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Announce' => array ( 'field_data' => array ( 'field' => 'Announce', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Sink' => array ( 'field_data' => array ( 'field' => 'Sink', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateIPAddress' => array ( 'field_data' => array ( 'field' => 'UpdateIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateLastComment' => array ( 'field_data' => array ( 'field' => 'DateLastComment', 'type' => 'datetime', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'LastCommentUserID' => array ( 'field_data' => array ( 'field' => 'LastCommentUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RegardingID' => array ( 'field_data' => array ( 'field' => 'RegardingID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'DiscussionID', ), 'GDN_Draft' => array ( 'fields' => array ( 'DraftID' => array ( 'field_data' => array ( 'field' => 'DraftID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'DiscussionID' => array ( 'field_data' => array ( 'field' => 'DiscussionID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Tags' => array ( 'field_data' => array ( 'field' => 'Tags', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Closed' => array ( 'field_data' => array ( 'field' => 'Closed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Announce' => array ( 'field_data' => array ( 'field' => 'Announce', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Sink' => array ( 'field_data' => array ( 'field' => 'Sink', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Body' => array ( 'field_data' => array ( 'field' => 'Body', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Format' => array ( 'field_data' => array ( 'field' => 'Format', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'DraftID', ), 'GDN_Invitation' => array ( 'fields' => array ( 'InvitationID' => array ( 'field_data' => array ( 'field' => 'InvitationID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Email' => array ( 'field_data' => array ( 'field' => 'Email', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(50)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RoleIDs' => array ( 'field_data' => array ( 'field' => 'RoleIDs', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Code' => array ( 'field_data' => array ( 'field' => 'Code', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => 'UNI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AcceptedUserID' => array ( 'field_data' => array ( 'field' => 'AcceptedUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateAccepted' => array ( 'field_data' => array ( 'field' => 'DateAccepted', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateExpires' => array ( 'field_data' => array ( 'field' => 'DateExpires', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'InvitationID', ), 'GDN_Log' => array ( 'fields' => array ( 'LogID' => array ( 'field_data' => array ( 'field' => 'LogID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Operation' => array ( 'field_data' => array ( 'field' => 'Operation', 'type' => 'enum(\'Delete\',\'Edit\',\'Spam\',\'Moderate\',\'Pending\',\'Ban\',\'Error\')', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RecordType' => array ( 'field_data' => array ( 'field' => 'RecordType', 'type' => 'enum(\'Discussion\',\'Comment\',\'User\',\'Registration\',\'Activity\',\'ActivityComment\',\'Configuration\',\'Group\',\'Event\')', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TransactionLogID' => array ( 'field_data' => array ( 'field' => 'TransactionLogID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RecordID' => array ( 'field_data' => array ( 'field' => 'RecordID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RecordUserID' => array ( 'field_data' => array ( 'field' => 'RecordUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RecordDate' => array ( 'field_data' => array ( 'field' => 'RecordDate', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RecordIPAddress' => array ( 'field_data' => array ( 'field' => 'RecordIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'OtherUserIDs' => array ( 'field_data' => array ( 'field' => 'OtherUserIDs', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ParentRecordID' => array ( 'field_data' => array ( 'field' => 'ParentRecordID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Data' => array ( 'field_data' => array ( 'field' => 'Data', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CountGroup' => array ( 'field_data' => array ( 'field' => 'CountGroup', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'LogID', ), 'GDN_Media' => array ( 'fields' => array ( 'MediaID' => array ( 'field_data' => array ( 'field' => 'MediaID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Path' => array ( 'field_data' => array ( 'field' => 'Path', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Size' => array ( 'field_data' => array ( 'field' => 'Size', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignID' => array ( 'field_data' => array ( 'field' => 'ForeignID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ForeignTable' => array ( 'field_data' => array ( 'field' => 'ForeignTable', 'type' => 'varchar(24)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ImageWidth' => array ( 'field_data' => array ( 'field' => 'ImageWidth', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ImageHeight' => array ( 'field_data' => array ( 'field' => 'ImageHeight', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ThumbWidth' => array ( 'field_data' => array ( 'field' => 'ThumbWidth', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ThumbHeight' => array ( 'field_data' => array ( 'field' => 'ThumbHeight', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ThumbPath' => array ( 'field_data' => array ( 'field' => 'ThumbPath', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'MediaID', ), 'GDN_Message' => array ( 'fields' => array ( 'MessageID' => array ( 'field_data' => array ( 'field' => 'MessageID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Content' => array ( 'field_data' => array ( 'field' => 'Content', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Format' => array ( 'field_data' => array ( 'field' => 'Format', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AllowDismiss' => array ( 'field_data' => array ( 'field' => 'AllowDismiss', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Enabled' => array ( 'field_data' => array ( 'field' => 'Enabled', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Application' => array ( 'field_data' => array ( 'field' => 'Application', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Controller' => array ( 'field_data' => array ( 'field' => 'Controller', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Method' => array ( 'field_data' => array ( 'field' => 'Method', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'IncludeSubcategories' => array ( 'field_data' => array ( 'field' => 'IncludeSubcategories', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'AssetTarget' => array ( 'field_data' => array ( 'field' => 'AssetTarget', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CssClass' => array ( 'field_data' => array ( 'field' => 'CssClass', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Sort' => array ( 'field_data' => array ( 'field' => 'Sort', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'MessageID', ), 'GDN_Permission' => array ( 'fields' => array ( 'PermissionID' => array ( 'field_data' => array ( 'field' => 'PermissionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'RoleID' => array ( 'field_data' => array ( 'field' => 'RoleID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'JunctionTable' => array ( 'field_data' => array ( 'field' => 'JunctionTable', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'JunctionColumn' => array ( 'field_data' => array ( 'field' => 'JunctionColumn', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'JunctionID' => array ( 'field_data' => array ( 'field' => 'JunctionID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Email.View' => array ( 'field_data' => array ( 'field' => 'Garden.Email.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Settings.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Settings.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Settings.View' => array ( 'field_data' => array ( 'field' => 'Garden.Settings.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.SignIn.Allow' => array ( 'field_data' => array ( 'field' => 'Garden.SignIn.Allow', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Add' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Edit' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Delete' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Approve' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Approve', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Activity.Delete' => array ( 'field_data' => array ( 'field' => 'Garden.Activity.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Activity.View' => array ( 'field_data' => array ( 'field' => 'Garden.Activity.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Profiles.View' => array ( 'field_data' => array ( 'field' => 'Garden.Profiles.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Profiles.Edit' => array ( 'field_data' => array ( 'field' => 'Garden.Profiles.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Curation.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Curation.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Moderation.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Moderation.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.PersonalInfo.View' => array ( 'field_data' => array ( 'field' => 'Garden.PersonalInfo.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.AdvancedNotifications.Allow' => array ( 'field_data' => array ( 'field' => 'Garden.AdvancedNotifications.Allow', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Community.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Community.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Tokens.Add' => array ( 'field_data' => array ( 'field' => 'Garden.Tokens.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Tagging.Add' => array ( 'field_data' => array ( 'field' => 'Vanilla.Tagging.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Conversations.Moderation.Manage' => array ( 'field_data' => array ( 'field' => 'Conversations.Moderation.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Conversations.Conversations.Add' => array ( 'field_data' => array ( 'field' => 'Conversations.Conversations.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Approval.Require' => array ( 'field_data' => array ( 'field' => 'Vanilla.Approval.Require', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Me' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Me', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.View' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Add' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Edit' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Announce' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Announce', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Sink' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Sink', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Close' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Close', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Delete' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Add' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Edit' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Delete' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'PermissionID', ), 'GDN_Regarding' => array ( 'fields' => array ( 'RegardingID' => array ( 'field_data' => array ( 'field' => 'RegardingID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignType' => array ( 'field_data' => array ( 'field' => 'ForeignType', 'type' => 'varchar(32)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignID' => array ( 'field_data' => array ( 'field' => 'ForeignID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'OriginalContent' => array ( 'field_data' => array ( 'field' => 'OriginalContent', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ParentType' => array ( 'field_data' => array ( 'field' => 'ParentType', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ParentID' => array ( 'field_data' => array ( 'field' => 'ParentID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ForeignURL' => array ( 'field_data' => array ( 'field' => 'ForeignURL', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Comment' => array ( 'field_data' => array ( 'field' => 'Comment', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Reports' => array ( 'field_data' => array ( 'field' => 'Reports', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'RegardingID', ), 'GDN_Role' => array ( 'fields' => array ( 'RoleID' => array ( 'field_data' => array ( 'field' => 'RoleID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Description' => array ( 'field_data' => array ( 'field' => 'Description', 'type' => 'varchar(500)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'enum(\'guest\',\'unconfirmed\',\'applicant\',\'member\',\'moderator\',\'administrator\')', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Sort' => array ( 'field_data' => array ( 'field' => 'Sort', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Deletable' => array ( 'field_data' => array ( 'field' => 'Deletable', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'CanSession' => array ( 'field_data' => array ( 'field' => 'CanSession', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'PersonalInfo' => array ( 'field_data' => array ( 'field' => 'PersonalInfo', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'RoleID', ), 'GDN_Session' => array ( 'fields' => array ( 'SessionID' => array ( 'field_data' => array ( 'field' => 'SessionID', 'type' => 'char(32)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateExpires' => array ( 'field_data' => array ( 'field' => 'DateExpires', 'type' => 'datetime', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'SessionID', ), 'GDN_Spammer' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountSpam' => array ( 'field_data' => array ( 'field' => 'CountSpam', 'type' => 'smallint(5) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountDeletedSpam' => array ( 'field_data' => array ( 'field' => 'CountDeletedSpam', 'type' => 'smallint(5) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_Tag' => array ( 'fields' => array ( 'TagID' => array ( 'field_data' => array ( 'field' => 'TagID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'FullName' => array ( 'field_data' => array ( 'field' => 'FullName', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => 'MUL', 'default' => '', 'extra' => '', ), 'escape_type' => 2, ), 'ParentTagID' => array ( 'field_data' => array ( 'field' => 'ParentTagID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '-1', 'extra' => '', ), 'escape_type' => 1, ), 'CountDiscussions' => array ( 'field_data' => array ( 'field' => 'CountDiscussions', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'TagID', ), 'GDN_TagDiscussion' => array ( 'fields' => array ( 'TagID' => array ( 'field_data' => array ( 'field' => 'TagID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DiscussionID' => array ( 'field_data' => array ( 'field' => 'DiscussionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'TagID', ), 'GDN_User' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Password' => array ( 'field_data' => array ( 'field' => 'Password', 'type' => 'varbinary(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'HashMethod' => array ( 'field_data' => array ( 'field' => 'HashMethod', 'type' => 'varchar(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Photo' => array ( 'field_data' => array ( 'field' => 'Photo', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Title' => array ( 'field_data' => array ( 'field' => 'Title', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Location' => array ( 'field_data' => array ( 'field' => 'Location', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'About' => array ( 'field_data' => array ( 'field' => 'About', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Email' => array ( 'field_data' => array ( 'field' => 'Email', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ShowEmail' => array ( 'field_data' => array ( 'field' => 'ShowEmail', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Gender' => array ( 'field_data' => array ( 'field' => 'Gender', 'type' => 'enum(\'u\',\'m\',\'f\')', 'null' => 'NO', 'key' => '', 'default' => 'u', 'extra' => '', ), 'escape_type' => 2, ), 'CountVisits' => array ( 'field_data' => array ( 'field' => 'CountVisits', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountInvitations' => array ( 'field_data' => array ( 'field' => 'CountInvitations', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountNotifications' => array ( 'field_data' => array ( 'field' => 'CountNotifications', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InviteUserID' => array ( 'field_data' => array ( 'field' => 'InviteUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DiscoveryText' => array ( 'field_data' => array ( 'field' => 'DiscoveryText', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Preferences' => array ( 'field_data' => array ( 'field' => 'Preferences', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Permissions' => array ( 'field_data' => array ( 'field' => 'Permissions', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateSetInvitations' => array ( 'field_data' => array ( 'field' => 'DateSetInvitations', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateOfBirth' => array ( 'field_data' => array ( 'field' => 'DateOfBirth', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateFirstVisit' => array ( 'field_data' => array ( 'field' => 'DateFirstVisit', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateLastActive' => array ( 'field_data' => array ( 'field' => 'DateLastActive', 'type' => 'datetime', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'LastIPAddress' => array ( 'field_data' => array ( 'field' => 'LastIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateIPAddress' => array ( 'field_data' => array ( 'field' => 'UpdateIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'HourOffset' => array ( 'field_data' => array ( 'field' => 'HourOffset', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Admin' => array ( 'field_data' => array ( 'field' => 'Admin', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Confirmed' => array ( 'field_data' => array ( 'field' => 'Confirmed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Verified' => array ( 'field_data' => array ( 'field' => 'Verified', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Banned' => array ( 'field_data' => array ( 'field' => 'Banned', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Deleted' => array ( 'field_data' => array ( 'field' => 'Deleted', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Points' => array ( 'field_data' => array ( 'field' => 'Points', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountUnreadConversations' => array ( 'field_data' => array ( 'field' => 'CountUnreadConversations', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountDiscussions' => array ( 'field_data' => array ( 'field' => 'CountDiscussions', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountUnreadDiscussions' => array ( 'field_data' => array ( 'field' => 'CountUnreadDiscussions', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountComments' => array ( 'field_data' => array ( 'field' => 'CountComments', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountDrafts' => array ( 'field_data' => array ( 'field' => 'CountDrafts', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountBookmarks' => array ( 'field_data' => array ( 'field' => 'CountBookmarks', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_UserAuthentication' => array ( 'fields' => array ( 'ForeignUserKey' => array ( 'field_data' => array ( 'field' => 'ForeignUserKey', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ProviderKey' => array ( 'field_data' => array ( 'field' => 'ProviderKey', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'ForeignUserKey', ), 'GDN_UserAuthenticationNonce' => array ( 'fields' => array ( 'Nonce' => array ( 'field_data' => array ( 'field' => 'Nonce', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Token' => array ( 'field_data' => array ( 'field' => 'Token', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Timestamp' => array ( 'field_data' => array ( 'field' => 'Timestamp', 'type' => 'timestamp', 'null' => 'NO', 'key' => 'MUL', 'default' => 'current_timestamp()', 'extra' => 'on update current_timestamp()', ), 'escape_type' => 2, ), ), 'primary_key' => 'Nonce', ), 'GDN_UserAuthenticationProvider' => array ( 'fields' => array ( 'AuthenticationKey' => array ( 'field_data' => array ( 'field' => 'AuthenticationKey', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AuthenticationSchemeAlias' => array ( 'field_data' => array ( 'field' => 'AuthenticationSchemeAlias', 'type' => 'varchar(32)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(50)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'URL' => array ( 'field_data' => array ( 'field' => 'URL', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AssociationSecret' => array ( 'field_data' => array ( 'field' => 'AssociationSecret', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AssociationHashMethod' => array ( 'field_data' => array ( 'field' => 'AssociationHashMethod', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AuthenticateUrl' => array ( 'field_data' => array ( 'field' => 'AuthenticateUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RegisterUrl' => array ( 'field_data' => array ( 'field' => 'RegisterUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'SignInUrl' => array ( 'field_data' => array ( 'field' => 'SignInUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'SignOutUrl' => array ( 'field_data' => array ( 'field' => 'SignOutUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'PasswordUrl' => array ( 'field_data' => array ( 'field' => 'PasswordUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ProfileUrl' => array ( 'field_data' => array ( 'field' => 'ProfileUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Active' => array ( 'field_data' => array ( 'field' => 'Active', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'IsDefault' => array ( 'field_data' => array ( 'field' => 'IsDefault', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'AuthenticationKey', ), 'GDN_UserAuthenticationToken' => array ( 'fields' => array ( 'Token' => array ( 'field_data' => array ( 'field' => 'Token', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ProviderKey' => array ( 'field_data' => array ( 'field' => 'ProviderKey', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignUserKey' => array ( 'field_data' => array ( 'field' => 'ForeignUserKey', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TokenSecret' => array ( 'field_data' => array ( 'field' => 'TokenSecret', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TokenType' => array ( 'field_data' => array ( 'field' => 'TokenType', 'type' => 'enum(\'request\',\'access\')', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Authorized' => array ( 'field_data' => array ( 'field' => 'Authorized', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Timestamp' => array ( 'field_data' => array ( 'field' => 'Timestamp', 'type' => 'timestamp', 'null' => 'NO', 'key' => 'MUL', 'default' => 'current_timestamp()', 'extra' => 'on update current_timestamp()', ), 'escape_type' => 2, ), 'Lifetime' => array ( 'field_data' => array ( 'field' => 'Lifetime', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'Token', ), 'GDN_UserCategory' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateMarkedRead' => array ( 'field_data' => array ( 'field' => 'DateMarkedRead', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Followed' => array ( 'field_data' => array ( 'field' => 'Followed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Unfollow' => array ( 'field_data' => array ( 'field' => 'Unfollow', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_UserComment' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CommentID' => array ( 'field_data' => array ( 'field' => 'CommentID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateLastViewed' => array ( 'field_data' => array ( 'field' => 'DateLastViewed', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserConversation' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ConversationID' => array ( 'field_data' => array ( 'field' => 'ConversationID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountReadMessages' => array ( 'field_data' => array ( 'field' => 'CountReadMessages', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'LastMessageID' => array ( 'field_data' => array ( 'field' => 'LastMessageID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateLastViewed' => array ( 'field_data' => array ( 'field' => 'DateLastViewed', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateCleared' => array ( 'field_data' => array ( 'field' => 'DateCleared', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Bookmarked' => array ( 'field_data' => array ( 'field' => 'Bookmarked', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Deleted' => array ( 'field_data' => array ( 'field' => 'Deleted', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateConversationUpdated' => array ( 'field_data' => array ( 'field' => 'DateConversationUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserDiscussion' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DiscussionID' => array ( 'field_data' => array ( 'field' => 'DiscussionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CountComments' => array ( 'field_data' => array ( 'field' => 'CountComments', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateLastViewed' => array ( 'field_data' => array ( 'field' => 'DateLastViewed', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Dismissed' => array ( 'field_data' => array ( 'field' => 'Dismissed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Bookmarked' => array ( 'field_data' => array ( 'field' => 'Bookmarked', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Participated' => array ( 'field_data' => array ( 'field' => 'Participated', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_UserIP' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'IPAddress' => array ( 'field_data' => array ( 'field' => 'IPAddress', 'type' => 'varbinary(16)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserMerge' => array ( 'fields' => array ( 'MergeID' => array ( 'field_data' => array ( 'field' => 'MergeID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'OldUserID' => array ( 'field_data' => array ( 'field' => 'OldUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'NewUserID' => array ( 'field_data' => array ( 'field' => 'NewUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'MergeID', ), 'GDN_UserMergeItem' => array ( 'fields' => array ( 'MergeID' => array ( 'field_data' => array ( 'field' => 'MergeID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Table' => array ( 'field_data' => array ( 'field' => 'Table', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Column' => array ( 'field_data' => array ( 'field' => 'Column', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RecordID' => array ( 'field_data' => array ( 'field' => 'RecordID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'OldUserID' => array ( 'field_data' => array ( 'field' => 'OldUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'NewUserID' => array ( 'field_data' => array ( 'field' => 'NewUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'GDN_UserMeta' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Value' => array ( 'field_data' => array ( 'field' => 'Value', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserPoints' => array ( 'fields' => array ( 'SlotType' => array ( 'field_data' => array ( 'field' => 'SlotType', 'type' => 'enum(\'d\',\'w\',\'m\',\'y\',\'a\')', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TimeSlot' => array ( 'field_data' => array ( 'field' => 'TimeSlot', 'type' => 'datetime', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Source' => array ( 'field_data' => array ( 'field' => 'Source', 'type' => 'varchar(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => 'Total', 'extra' => '', ), 'escape_type' => 2, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Points' => array ( 'field_data' => array ( 'field' => 'Points', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'SlotType', ), 'GDN_UserRole' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RoleID' => array ( 'field_data' => array ( 'field' => 'RoleID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'average_ratings' => array ( 'fields' => array ( 'ep_combo_id' => array ( 'field_data' => array ( 'field' => 'ep_combo_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'average_rating' => array ( 'field_data' => array ( 'field' => 'average_rating', 'type' => 'decimal(7,4)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => NULL, ), 'click_outs' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_type' => array ( 'field_data' => array ( 'field' => 'data_type', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'ip' => array ( 'field_data' => array ( 'field' => 'ip', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'comments_vanilla_connect' => array ( 'fields' => array ( 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_comment_id' => array ( 'field_data' => array ( 'field' => 'vanilla_comment_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'comments_vanilla_votes' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_comment_id' => array ( 'field_data' => array ( 'field' => 'vanilla_comment_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'vote' => array ( 'field_data' => array ( 'field' => 'vote', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'delete_it' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'discussion_vanilla_votes' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_discussion_id' => array ( 'field_data' => array ( 'field' => 'vanilla_discussion_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'vote' => array ( 'field_data' => array ( 'field' => 'vote', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'discussions_vanilla_connect' => array ( 'fields' => array ( 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_discussion_id' => array ( 'field_data' => array ( 'field' => 'vanilla_discussion_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'vanilla_discussion_id', ), 'experiment_bookmarks' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_option_id' => array ( 'field_data' => array ( 'field' => 'experiment_option_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'experiment_circle' => array ( 'fields' => array ( 'experiment_circle_id' => array ( 'field_data' => array ( 'field' => 'experiment_circle_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'experiment_circle_id', ), 'experiment_circleBAK' => array ( 'fields' => array ( 'experiment_circle_id' => array ( 'field_data' => array ( 'field' => 'experiment_circle_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'experiment_circle_id', ), 'experiment_combos' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'experiment_option_id' => array ( 'field_data' => array ( 'field' => 'experiment_option_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'link_to_combo_id' => array ( 'field_data' => array ( 'field' => 'link_to_combo_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'product_id' => array ( 'field_data' => array ( 'field' => 'product_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'author_email' => array ( 'field_data' => array ( 'field' => 'author_email', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'author_pubmed_url' => array ( 'field_data' => array ( 'field' => 'author_pubmed_url', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'publication_status' => array ( 'field_data' => array ( 'field' => 'publication_status', 'type' => 'int(1) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'tips_upstream' => array ( 'field_data' => array ( 'field' => 'tips_upstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'tips_protocol' => array ( 'field_data' => array ( 'field' => 'tips_protocol', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'tips_downstream' => array ( 'field_data' => array ( 'field' => 'tips_downstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'publication_protocol' => array ( 'field_data' => array ( 'field' => 'publication_protocol', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'youtube_video_id' => array ( 'field_data' => array ( 'field' => 'youtube_video_id', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'exclude_product_youtube_video_id' => array ( 'field_data' => array ( 'field' => 'exclude_product_youtube_video_id', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'experiment_endpoints' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'experiment_endpoints_bak' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'experiment_endpoints_bak2' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'experiment_options' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_id' => array ( 'field_data' => array ( 'field' => 'experiment_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'parent_id' => array ( 'field_data' => array ( 'field' => 'parent_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'alt_step_title' => array ( 'field_data' => array ( 'field' => 'alt_step_title', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'alt_subtype_label' => array ( 'field_data' => array ( 'field' => 'alt_subtype_label', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'order' => array ( 'field_data' => array ( 'field' => 'order', 'type' => 'tinyint(4)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => 'MUL', 'default' => 'active', 'extra' => '', ), 'escape_type' => 2, ), 'experiment_challenge' => array ( 'field_data' => array ( 'field' => 'experiment_challenge', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'experiment_questions' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_id' => array ( 'field_data' => array ( 'field' => 'experiment_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'order' => array ( 'field_data' => array ( 'field' => 'order', 'type' => 'tinyint(4)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'experiment_suggestions' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_email' => array ( 'field_data' => array ( 'field' => 'suggester_email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_name' => array ( 'field_data' => array ( 'field' => 'suggester_name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'experiment_titles' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'experiments' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'step_titles' => array ( 'field_data' => array ( 'field' => 'step_titles', 'type' => 'varchar(2048)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'active' => array ( 'field_data' => array ( 'field' => 'active', 'type' => 'tinyint(3) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'launch_leads' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'experiment' => array ( 'field_data' => array ( 'field' => 'experiment', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pubmed_links' => array ( 'field_data' => array ( 'field' => 'pubmed_links', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'login_history' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'manufacturers' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'bio' => array ( 'field_data' => array ( 'field' => 'bio', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'website' => array ( 'field_data' => array ( 'field' => 'website', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'missed_searches' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'search' => array ( 'field_data' => array ( 'field' => 'search', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'notifications' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'enum(\'1\',\'2\')', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 2, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'secondary_user_id' => array ( 'field_data' => array ( 'field' => 'secondary_user_id', 'type' => 'int(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'secondary_item_id' => array ( 'field_data' => array ( 'field' => 'secondary_item_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'system_code' => array ( 'field_data' => array ( 'field' => 'system_code', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'description' => array ( 'field_data' => array ( 'field' => 'description', 'type' => 'varchar(1024)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'url' => array ( 'field_data' => array ( 'field' => 'url', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'mail_status' => array ( 'field_data' => array ( 'field' => 'mail_status', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'product_categories' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'products' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'category_id' => array ( 'field_data' => array ( 'field' => 'category_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'manufacturer_id' => array ( 'field_data' => array ( 'field' => 'manufacturer_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'website' => array ( 'field_data' => array ( 'field' => 'website', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_email' => array ( 'field_data' => array ( 'field' => 'suggester_email', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_name' => array ( 'field_data' => array ( 'field' => 'suggester_name', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => 'active', 'extra' => '', ), 'escape_type' => 2, ), 'youtube_video_id_product' => array ( 'field_data' => array ( 'field' => 'youtube_video_id_product', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'external_product_id' => array ( 'field_data' => array ( 'field' => 'external_product_id', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'deeplink_url' => array ( 'field_data' => array ( 'field' => 'deeplink_url', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'publications' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_combo_id' => array ( 'field_data' => array ( 'field' => 'experiment_combo_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'url' => array ( 'field_data' => array ( 'field' => 'url', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'abstract' => array ( 'field_data' => array ( 'field' => 'abstract', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'materials_and_methods' => array ( 'field_data' => array ( 'field' => 'materials_and_methods', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'author_1' => array ( 'field_data' => array ( 'field' => 'author_1', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'raw_xml' => array ( 'field_data' => array ( 'field' => 'raw_xml', 'type' => 'mediumtext', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'registrations' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'password' => array ( 'field_data' => array ( 'field' => 'password', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'rank' => array ( 'field_data' => array ( 'field' => 'rank', 'type' => 'varchar(64)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'first_name' => array ( 'field_data' => array ( 'field' => 'first_name', 'type' => 'varchar(64)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'last_name' => array ( 'field_data' => array ( 'field' => 'last_name', 'type' => 'varchar(64)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'activation_hash' => array ( 'field_data' => array ( 'field' => 'activation_hash', 'type' => 'varchar(41)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'review_discussions' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'review_id' => array ( 'field_data' => array ( 'field' => 'review_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'message' => array ( 'field_data' => array ( 'field' => 'message', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'review_products' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'review_id' => array ( 'field_data' => array ( 'field' => 'review_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'product_id' => array ( 'field_data' => array ( 'field' => 'product_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol' => array ( 'field_data' => array ( 'field' => 'protocol', 'type' => 'varchar(10)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjustment' => array ( 'field_data' => array ( 'field' => 'protocol_adjustment', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjusted_upstream' => array ( 'field_data' => array ( 'field' => 'protocol_adjusted_upstream', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol_details_upstream' => array ( 'field_data' => array ( 'field' => 'protocol_details_upstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjusted_protocol' => array ( 'field_data' => array ( 'field' => 'protocol_adjusted_protocol', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol_details_protocol' => array ( 'field_data' => array ( 'field' => 'protocol_details_protocol', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjusted_downstream' => array ( 'field_data' => array ( 'field' => 'protocol_adjusted_downstream', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol_details_downstream' => array ( 'field_data' => array ( 'field' => 'protocol_details_downstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_desc' => array ( 'field_data' => array ( 'field' => 'protocol_desc', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'comments' => array ( 'field_data' => array ( 'field' => 'comments', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_friendly' => array ( 'field_data' => array ( 'field' => 'user_friendly', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'time' => array ( 'field_data' => array ( 'field' => 'time', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'quality' => array ( 'field_data' => array ( 'field' => 'quality', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'pro_1' => array ( 'field_data' => array ( 'field' => 'pro_1', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pro_2' => array ( 'field_data' => array ( 'field' => 'pro_2', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pro_3' => array ( 'field_data' => array ( 'field' => 'pro_3', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'con_1' => array ( 'field_data' => array ( 'field' => 'con_1', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'con_2' => array ( 'field_data' => array ( 'field' => 'con_2', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'con_3' => array ( 'field_data' => array ( 'field' => 'con_3', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'recommend' => array ( 'field_data' => array ( 'field' => 'recommend', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'review_ratings' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'review_id' => array ( 'field_data' => array ( 'field' => 'review_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'rating_complete' => array ( 'field_data' => array ( 'field' => 'rating_complete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'rating_product' => array ( 'field_data' => array ( 'field' => 'rating_product', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'rating_explanation' => array ( 'field_data' => array ( 'field' => 'rating_explanation', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'reviews' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ep_combo_id' => array ( 'field_data' => array ( 'field' => 'ep_combo_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'additional_info' => array ( 'field_data' => array ( 'field' => 'additional_info', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pubmed_link' => array ( 'field_data' => array ( 'field' => 'pubmed_link', 'type' => 'tinytext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'scientific_name' => array ( 'field_data' => array ( 'field' => 'scientific_name', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email_address' => array ( 'field_data' => array ( 'field' => 'email_address', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'root_tables' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'options' => array ( 'field_data' => array ( 'field' => 'options', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'synonyms' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'type' => array ( 'field_data' => array ( 'field' => 'type', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'word' => array ( 'field_data' => array ( 'field' => 'word', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'synonym' => array ( 'field_data' => array ( 'field' => 'synonym', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'system_history' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'system_code' => array ( 'field_data' => array ( 'field' => 'system_code', 'type' => 'varchar(32)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'description' => array ( 'field_data' => array ( 'field' => 'description', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'test' => array ( 'fields' => array ( 'a' => array ( 'field_data' => array ( 'field' => 'a', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'b' => array ( 'field_data' => array ( 'field' => 'b', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'user_activity' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_type' => array ( 'field_data' => array ( 'field' => 'data_type', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'ip' => array ( 'field_data' => array ( 'field' => 'ip', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'user_connections' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'user_connection_id' => array ( 'field_data' => array ( 'field' => 'user_connection_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'type' => array ( 'field_data' => array ( 'field' => 'type', 'type' => 'tinyint(1)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'tinyint(1)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'user_profiles' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'oauth_provider' => array ( 'field_data' => array ( 'field' => 'oauth_provider', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'oauth_uid' => array ( 'field_data' => array ( 'field' => 'oauth_uid', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'scientific_name' => array ( 'field_data' => array ( 'field' => 'scientific_name', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'fname' => array ( 'field_data' => array ( 'field' => 'fname', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'lname' => array ( 'field_data' => array ( 'field' => 'lname', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'location' => array ( 'field_data' => array ( 'field' => 'location', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'country' => array ( 'field_data' => array ( 'field' => 'country', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'picture_url' => array ( 'field_data' => array ( 'field' => 'picture_url', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'profile_url' => array ( 'field_data' => array ( 'field' => 'profile_url', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'function_title' => array ( 'field_data' => array ( 'field' => 'function_title', 'type' => 'varchar(200)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'company' => array ( 'field_data' => array ( 'field' => 'company', 'type' => 'varchar(200)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'bio' => array ( 'field_data' => array ( 'field' => 'bio', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_type' => array ( 'field_data' => array ( 'field' => 'user_type', 'type' => 'varchar(10)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_institution' => array ( 'field_data' => array ( 'field' => 'user_institution', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_department' => array ( 'field_data' => array ( 'field' => 'user_department', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_company' => array ( 'field_data' => array ( 'field' => 'user_company', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_division' => array ( 'field_data' => array ( 'field' => 'user_division', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_position' => array ( 'field_data' => array ( 'field' => 'user_position', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'modified' => array ( 'field_data' => array ( 'field' => 'modified', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email_discussion' => array ( 'field_data' => array ( 'field' => 'email_discussion', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'email_circle' => array ( 'field_data' => array ( 'field' => 'email_circle', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'linkedin_url' => array ( 'field_data' => array ( 'field' => 'linkedin_url', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'expertise_experiment_id' => array ( 'field_data' => array ( 'field' => 'expertise_experiment_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'pubmed_links' => array ( 'field_data' => array ( 'field' => 'pubmed_links', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'salt_1' => array ( 'field_data' => array ( 'field' => 'salt_1', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'salt_2' => array ( 'field_data' => array ( 'field' => 'salt_2', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'user_status_updates' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'content' => array ( 'field_data' => array ( 'field' => 'content', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'users' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => '', 'default' => 'active', 'extra' => '', ), 'escape_type' => 2, ), 'registration_status' => array ( 'field_data' => array ( 'field' => 'registration_status', 'type' => 'enum(\'1\',\'2\')', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'password' => array ( 'field_data' => array ( 'field' => 'password', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'rank' => array ( 'field_data' => array ( 'field' => 'rank', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(128)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'users_vanilla_connect' => array ( 'fields' => array ( 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_user_id' => array ( 'field_data' => array ( 'field' => 'vanilla_user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'UNI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_access_token' => array ( 'field_data' => array ( 'field' => 'vanilla_access_token', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'labettor_user_id', ), ); Labettor

ChIP acH3 - Bovine Horse

Start discussion

No discussions found

Start your discussion

Share your thoughts or question with experts in your field

Start a discussion

No matching solutions found

Oh snap! We couldn't find any matching products

We'd love it if you would contribute to the research community by telling us about the product you've used to perform this experiment!

Outsource your experiment

Fill out your contact details and receive price quotes in your Inbox

  Outsource experiment
Become shareholder Discussions About us Contact Privacy Terms